explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DZTz

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 26,097.453 ↑ 1.0 1 1

Finalize Aggregate (cost=230,941.41..230,941.42 rows=1 width=8) (actual time=26,097.452..26,097.453 rows=1 loops=1)

2. 14.224 26,097.441 ↓ 1.5 3 1

Gather (cost=230,941.20..230,941.41 rows=2 width=8) (actual time=26,097.426..26,097.441 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 22.419 26,083.217 ↑ 1.0 1 3

Partial Aggregate (cost=229,941.20..229,941.21 rows=1 width=8) (actual time=26,083.216..26,083.217 rows=1 loops=3)

4. 9,030.117 26,060.798 ↑ 1.2 50,174 3

Nested Loop (cost=6,233.02..229,786.91 rows=61,715 width=0) (actual time=11,967.996..26,060.798 rows=50,174 loops=3)

5. 5,125.643 17,030.502 ↑ 1.2 50,174 3

Parallel Bitmap Heap Scan on tbl_proj_com_history_item this_ (cost=6,232.46..102,614.74 rows=61,715 width=33) (actual time=11,957.766..17,030.502 rows=50,174 loops=3)

  • Recheck Cond: ((dialproject)::text = 'corebo00000000000m70pt4aqgmt59n8'::text)
  • Heap Blocks: exact=21655
6. 11,904.859 11,904.859 ↓ 1.0 150,521 1

Bitmap Index Scan on idx_fk116 (cost=0.00..6,195.44 rows=148,117 width=0) (actual time=11,904.859..11,904.859 rows=150,521 loops=1)

  • Index Cond: ((dialproject)::text = 'corebo00000000000m70pt4aqgmt59n8'::text)
7. 0.179 0.179 ↑ 1.0 1 150,521

Index Only Scan using tbl_change_history_item_pkey on tbl_change_history_item this_1_ (cost=0.56..2.06 rows=1 width=33) (actual time=0.179..0.179 rows=1 loops=150,521)

  • Index Cond: (uuid = (this_.uuid)::text)
  • Heap Fetches: 7075
Planning time : 225.410 ms
Execution time : 26,157.165 ms