explain.depesz.com

PostgreSQL's explain analyze made readable

Result: erpn

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 888.197 ↑ 1.0 1 1

Finalize Aggregate (cost=93,543.34..93,543.35 rows=1 width=8) (actual time=888.197..888.197 rows=1 loops=1)

2. 24.963 905.373 ↓ 1.5 3 1

Gather (cost=93,543.13..93,543.34 rows=2 width=8) (actual time=888.073..905.373 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.056 880.410 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=92,543.13..92,543.14 rows=1 width=8) (actual time=880.409..880.410 rows=1 loops=3)

4. 0.332 880.354 ↓ 9.0 27 3 / 3

Nested Loop (cost=0.43..92,543.12 rows=3 width=4) (actual time=200.620..880.354 rows=27 loops=3)

5. 878.006 878.006 ↑ 13.0 112 3 / 3

Parallel Seq Scan on utility_bills ub (cost=0.00..89,331.36 rows=1,457 width=20) (actual time=9.796..878.006 rows=112 loops=3)

  • Filter: ((review_utility_bill_id IS NOT NULL) AND (reviewed_on IS NULL) AND (reviewed_by IS NULL) AND (deleted_by IS NULL) AND (deleted_on IS NULL))
  • Rows Removed by Filter: 743303
6. 2.016 2.016 ↓ 0.0 0 336 / 3

Index Scan using pk_utility_bills on utility_bills ubr (cost=0.43..2.20 rows=1 width=4) (actual time=0.018..0.018 rows=0 loops=336)

  • Index Cond: (id = ub.review_utility_bill_id)
  • Filter: ((deleted_by IS NULL) AND (deleted_on IS NULL))
  • Rows Removed by Filter: 1
Planning time : 0.654 ms
Execution time : 905.581 ms