#	exclusive	inclusive	rows x	rows	loops	node
1.	0.019	0.204	↑ 1.0	1	1	→ Aggregate (cost=109.00..109.20 rows=1 width=8) (actual time=0.203..0.204 rows=1 loops=1)
2.	0.136	0.185	↓ 1.0	28	1	→ Bitmap Heap Scan on cards (cost=4.51..108.93 rows=27 width=0) (actual time=0.092..0.185 rows=28 loops=1) Recheck Cond: (thread_reply_id = '85d4dcce-d170-4374-9754-4ba3a03e206e'::uuid) Filter: (deleted_at IS NULL) Rows Removed by Filter: 1 Heap Blocks: exact=28
3.	0.049	0.049	↑ 1.0	29	1	→ Bitmap Index Scan on cards_thread_reply_id_idx (cost=0.00..4.50 rows=29 width=0) (actual time=0.049..0.049 rows=29 loops=1) Index Cond: (thread_reply_id = '85d4dcce-d170-4374-9754-4ba3a03e206e'::uuid)

"Aggregate  (cost=109.00..109.20 rows=1 width=8) (actual time=0.203..0.204 rows=1 loops=1)"
"  ->  Bitmap Heap Scan on cards  (cost=4.51..108.93 rows=27 width=0) (actual time=0.092..0.185 rows=28 loops=1)"
"        Recheck Cond: (thread_reply_id = '85d4dcce-d170-4374-9754-4ba3a03e206e'::uuid)"
"        Filter: (deleted_at IS NULL)"
"        Rows Removed by Filter: 1"
"        Heap Blocks: exact=28"
"        ->  Bitmap Index Scan on cards_thread_reply_id_idx  (cost=0.00..4.50 rows=29 width=0) (actual time=0.049..0.049 rows=29 loops=1)"
"              Index Cond: (thread_reply_id = '85d4dcce-d170-4374-9754-4ba3a03e206e'::uuid)"
"Planning time: 0.461 ms"
"Execution time: 0.366 ms"

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	0.019 ms	9.3 %
Bitmap Heap Scan	1	0.136 ms	66.7 %
Bitmap Index Scan	1	0.049 ms	24.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
cards	1	0.136 ms	66.7 %
Bitmap Heap Scan	1	0.136 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sKat

Color mode:

Visible columns:

Per node type stats

Per table stats