explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5vtz

Settings
# exclusive inclusive rows x rows loops node
1. 1.201 1,159.373 ↑ 1.0 100 1

Limit (cost=14,496.42..14,512.55 rows=100 width=127) (actual time=1,155.739..1,159.373 rows=100 loops=1)

2. 1.374 1,158.172 ↑ 5,105.4 100 1

Unique (cost=14,496.42..96,884.76 rows=510,543 width=127) (actual time=1,155.725..1,158.172 rows=100 loops=1)

3. 591.441 1,156.798 ↑ 5,105.4 100 1

Index Scan using inspections_purchaseorder_pkey on inspections_purchaseorder (cost=14,496.42..95,608.41 rows=510,543 width=127) (actual time=1,155.710..1,156.798 rows=100 loops=1)

  • Filter: ((org_id = 252,437) OR ((org_id <> 252437) AND (hashed SubPlan 1)))
  • Rows Removed by Filter: 219
4.          

SubPlan (for Index Scan)

5. 558.741 565.357 ↑ 1.0 76,072 1

Bitmap Heap Scan on inspections_purchaseordershare u0 (cost=1,459.59..14,301.42 rows=77,827 width=4) (actual time=7.637..565.357 rows=76,072 loops=1)

  • Recheck Cond: (share_to_org_id = 252,437)
  • Heap Blocks: exact=7,002
6. 6.616 6.616 ↑ 1.0 76,072 1

Bitmap Index Scan on inspections_purchaseordershare_share_to_org_id_c6418aa1 (cost=0.00..1,440.13 rows=77,827 width=0) (actual time=6.604..6.616 rows=76,072 loops=1)

  • Index Cond: (share_to_org_id = 252,437)
Planning time : 11.594 ms
Execution time : 1,161.058 ms