
pgBadger :: 

- Global information ---------------------------------------------------

Generated on Sat Nov  7 14:10:21 2026
Log file: fixture/paired-record.log
Parsed 76 log entries in 2s
Log start from 2026-11-07 09:00:00 to 2026-11-07 09:00:38



- Overall statistics ---------------------------------------------------

Number of unique normalized queries: 4
Number of queries: 28
Total query duration: 4s972ms
First query: 2026-11-07 09:00:00
Last query: 2026-11-07 09:00:38
Query peak: 2 queries/s at 2026-11-07 09:00:08
Number of events: 0
Number of unique normalized events: 0


- Hourly statistics ----------------------------------------------------

Report not supported by text format


- Queries by type ------------------------------------------------------

Type     Count     Percentage
SELECT: 28 100.00%
INSERT: 0 0.00%
UPDATE: 0 0.00%
DELETE: 0 0.00%
COPY FROM: 0 0.00%
COPY TO: 0 0.00%
CTE: 0 0.00%
DDL: 0 0.00%
TCL: 0 0.00%
CURSOR: 0 0.00%


- Request per user ------------------------------------------------------

User     Request type     Count    duration
learner1 - 14 2s416ms
	select 14 2s416ms
learner2 - 14 2s556ms
	select 14 2s556ms

- Slowest queries ------------------------------------------------------

Rank     Duration (s)     Query
1) 290ms database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;
--
2) 280ms database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
--
3) 270ms database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
--
4) 260ms database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;
--
5) 250ms database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;
--
6) 240ms database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
--
7) 230ms database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
--
8) 220ms database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;
--
9) 210ms database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;
--
10) 200ms database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
--
11) 190ms database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
--
12) 180ms database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;
--
13) 170ms database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;
--
14) 169ms database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;

--
15) 160ms database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
--
16) 159ms database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;

--
17) 150ms database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
--
18) 149ms database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;

--
19) 140ms database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;
--
20) 139ms database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;

--

- Queries that took up the most time (N) -------------------------------

Rank     Total duration      Times executed     Min/Max/Avg duration (s)     Query
1) 1s348ms - 7 - 129ms/290ms/192ms - select item_id, quantity from inventory where quantity > ?;
--
	- Example 1: 290ms - database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;
	- Example 2: 250ms - database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;
	- Example 3: 210ms - database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;
2) 1s278ms - 7 - 119ms/280ms/182ms - select course_id, price_naira from courses where active = true;
--
	- Example 1: 280ms - database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
	- Example 2: 240ms - database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
	- Example 3: 200ms - database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
3) 1s208ms - 7 - 109ms/270ms/172ms - select count(*) from enrolments where course_id = ?;
--
	- Example 1: 270ms - database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
	- Example 2: 230ms - database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
	- Example 3: 190ms - database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
4) 1s138ms - 7 - 99ms/260ms/162ms - select course_id, title from courses where active = true;
--
	- Example 1: 260ms - database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;
	- Example 2: 220ms - database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;
	- Example 3: 180ms - database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;

- Most frequent queries (N) --------------------------------------------

Rank     Times executed     Total duration     Min/Max/Avg duration (s)     Query
1) 7 - 1s278ms - 119ms/280ms/182ms - select course_id, price_naira from courses where active = true;
--
	Example 1: 280ms - database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
	Example 2: 240ms - database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
	Example 3: 200ms - database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
2) 7 - 1s208ms - 109ms/270ms/172ms - select count(*) from enrolments where course_id = ?;
--
	Example 1: 270ms - database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
	Example 2: 230ms - database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
	Example 3: 190ms - database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
3) 7 - 1s348ms - 129ms/290ms/192ms - select item_id, quantity from inventory where quantity > ?;
--
	Example 1: 290ms - database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;
	Example 2: 250ms - database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;
	Example 3: 210ms - database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;
4) 7 - 1s138ms - 99ms/260ms/162ms - select course_id, title from courses where active = true;
--
	Example 1: 260ms - database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;
	Example 2: 220ms - database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;
	Example 3: 180ms - database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;

- Slowest queries (N) --------------------------------------------------

Rank     Min/Max/Avg duration (s)     Times executed     Total duration     Query
1) 129ms/290ms/192ms - 7 - 1s348ms - select item_id, quantity from inventory where quantity > ?;
--
	Example 1: 290ms - database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;
	Example 2: 250ms - database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;
	Example 3: 210ms - database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;
2) 119ms/280ms/182ms - 7 - 1s278ms - select course_id, price_naira from courses where active = true;
--
	Example 1: 280ms - database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
	Example 2: 240ms - database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
	Example 3: 200ms - database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
3) 109ms/270ms/172ms - 7 - 1s208ms - select count(*) from enrolments where course_id = ?;
--
	Example 1: 270ms - database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
	Example 2: 230ms - database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
	Example 3: 190ms - database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
4) 99ms/260ms/162ms - 7 - 1s138ms - select course_id, title from courses where active = true;
--
	Example 1: 260ms - database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;
	Example 2: 220ms - database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;
	Example 3: 180ms - database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;

- Most frequent events (N) ---------------------------------------------


- Logs per type ---------------------------------------------

Logs type	Count	Percentage
LOG		28	100.00%


Report generated by pgBadger 13.2 (http://pgbadger.darold.net/).
