
pgBadger :: 

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

Generated on Sat Nov  7 14:10:19 2026
Log file: fixture/single-record.log
Parsed 60 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: 20
Total query duration: 3s900ms
First query: 2026-11-07 09:00:00
Last query: 2026-11-07 09:00:38
Query peak: 1 queries/s at 2026-11-07 09:00:00
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: 20 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 - 10 1s900ms
	select 10 1s900ms
learner2 - 10 2s
	select 10 2s

- 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) 160ms database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
--
15) 150ms database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
--
16) 140ms database: course_demo, user: learner1 - SELECT course_id, title FROM courses WHERE active = true;
--
17) 130ms database: course_demo, user: learner2 - SELECT item_id, quantity FROM inventory WHERE quantity > 0;
--
18) 120ms database: course_demo, user: learner1 - SELECT course_id, price_naira
	FROM courses
	WHERE active = true;
--
19) 110ms database: course_demo, user: learner2 - SELECT count(*) FROM enrolments WHERE course_id = 7;
--
20) 100ms 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) 1s50ms - 5 - 130ms/290ms/210ms - 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) 1s - 5 - 120ms/280ms/200ms - 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) 950ms - 5 - 110ms/270ms/190ms - 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) 900ms - 5 - 100ms/260ms/180ms - 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) 5 - 1s - 120ms/280ms/200ms - 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) 5 - 950ms - 110ms/270ms/190ms - 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) 5 - 1s50ms - 130ms/290ms/210ms - 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) 5 - 900ms - 100ms/260ms/180ms - 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) 130ms/290ms/210ms - 5 - 1s50ms - 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) 120ms/280ms/200ms - 5 - 1s - 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) 110ms/270ms/190ms - 5 - 950ms - 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) 100ms/260ms/180ms - 5 - 900ms - 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		20	100.00%


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