explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gflC

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 6,833.402 ↓ 0.0 0 1

Limit (cost=1.40..3,879.95 rows=10 width=43) (actual time=6,833.402..6,833.402 rows=0 loops=1)

2. 0.000 6,833.401 ↓ 0.0 0 1

Unique (cost=1.40..1,099,180.80 rows=2,834 width=43) (actual time=6,833.401..6,833.401 rows=0 loops=1)

3. 0.111 6,833.401 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.40..1,099,167.54 rows=5,304 width=43) (actual time=6,833.401..6,833.401 rows=0 loops=1)

  • Filter: ((inspections_purchaseordershare.share_to_org_id = 193659) OR (inspections_purchaseorder.org_id = 193659))
  • Rows Removed by Filter: 224
4. 0.008 6,833.178 ↑ 2,077.0 112 1

Nested Loop (cost=0.98..985,263.84 rows=232,629 width=51) (actual time=6,711.489..6,833.178 rows=112 loops=1)

5. 6,832.946 6,832.946 ↑ 2,077.0 112 1

Index Scan using inspections_purchaseorderitem_style_513f805a on inspections_purchaseorderitem (cost=0.56..796,095.22 rows=232,629 width=47) (actual time=6,711.477..6,832.946 rows=112 loops=1)

  • Filter: (upper((style)::text) ~~ '%K34%'::text)
  • Rows Removed by Filter: 5882929
6. 0.224 0.224 ↑ 1.0 1 112

Index Scan using inspections_purchaseorder_pkey on inspections_purchaseorder (cost=0.42..0.80 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=112)

  • Index Cond: (id = inspections_purchaseorderitem.purchase_order_id)
7. 0.112 0.112 ↑ 1.0 2 112

Index Only Scan using inspections_purchaseorde_po_id_share_to_org_id_a68a3a75_uniq on inspections_purchaseordershare (cost=0.42..0.46 rows=2 width=8) (actual time=0.001..0.001 rows=2 loops=112)

  • Index Cond: (po_id = inspections_purchaseorder.id)
  • Heap Fetches: 0
Planning time : 0.588 ms