explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EZZK

Settings
# exclusive inclusive rows x rows loops node
1. 1.494 1,107.304 ↑ 1.0 100 1

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

2. 1.399 1,105.810 ↑ 5,105.4 100 1

Group (cost=14,496.42..96,884.76 rows=510,543 width=127) (actual time=1,103.018..1,105.810 rows=100 loops=1)

  • Group Key: inspections_purchaseorder.id
3. 560.074 1,104.411 ↑ 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,103.003..1,104.411 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. 538.360 544.337 ↑ 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.027..544.337 rows=76,072 loops=1)

  • Recheck Cond: (share_to_org_id = 252,437)
  • Heap Blocks: exact=7,002
6. 5.977 5.977 ↑ 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=5.964..5.977 rows=76,072 loops=1)

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