explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4fi

Settings
# exclusive inclusive rows x rows loops node
1. 5.180 6.178 ↑ 1.0 10 1

Index Scan using waybills_idx_ims on waybills t0 (cost=0.45..339.73 rows=10 width=546) (actual time=5.565..6.178 rows=10 loops=1)

  • Index Cond: (id = ANY ('{19572556,19573726,19573729,19575020,19576239,19604604,19621528,19563861,19563860,19636886}'::integer[]))
2.          

SubPlan (forIndex Scan)

3. 0.000 0.000 ↓ 0.0 0

Limit (cost=8.59..8.59 rows=1 width=12) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Sort (cost=8.59..8.59 rows=1 width=12) (never executed)

  • Sort Key: deliveries.id
5. 0.000 0.000 ↓ 0.0 0

Index Scan using deliveries_waybill_idx on deliveries (cost=0.56..8.58 rows=1 width=12) (never executed)

  • Index Cond: (waybillid = t0.id)
6. 0.008 0.512 ↑ 1.0 1 1

Aggregate (cost=8.44..8.45 rows=1 width=4) (actual time=0.512..0.512 rows=1 loops=1)

7. 0.504 0.504 ↑ 1.0 1 1

Index Scan using waybills_idx_exchange_rrn_id_trgm on waybills ww (cost=0.42..8.44 rows=1 width=4) (actual time=0.343..0.504 rows=1 loops=1)

  • Index Cond: ((waybill_id)::text = (t0.exchange_rrn_id)::text)
  • Filter: (waybilltype = 'RRN'::bpchar)
8. 0.010 0.486 ↑ 1.0 1 2

Aggregate (cost=8.44..8.45 rows=1 width=4) (actual time=0.243..0.243 rows=1 loops=2)

9. 0.476 0.476 ↓ 0.0 0 2

Index Scan using waybills_idx_exchange_rrn_id_trgm on waybills ww_1 (cost=0.42..8.44 rows=1 width=4) (actual time=0.195..0.238 rows=0 loops=2)

  • Index Cond: ((exchange_rrn_id)::text = (t0.waybill_id)::text)
  • Filter: (waybilltype = 'XCH'::bpchar)