explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8lEh

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on trip_summary_coupon tsc (cost=937.94..64,275.72 rows=11,299 width=940) (actual rows= loops=)

  • Recheck Cond: ((trip_summary_id)::text = ANY ((($1)::character varying[])::text[]))
  • Filter: ((printer_type)::text = 'ZPL'::text)
2.          

Initplan (forBitmap Heap Scan)

3. 0.000 0.000 ↓ 0.0

Result (cost=8.59..8.60 rows=1 width=0) (actual rows= loops=)

4.          

Initplan (forResult)

5. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8.58..8.59 rows=1 width=33) (actual rows= loops=)

  • Group Key: trip_summary.trip_summary_id
6. 0.000 0.000 ↓ 0.0

Index Scan using trip_summary_idx12 on trip_summary (cost=0.56..8.58 rows=1 width=33) (actual rows= loops=)

  • Index Cond: (((confirmation_number)::text = '37050560'::text) AND ((passenger_last_name)::text = 'E'::text))
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on trip_summary_coupon_idx1 (cost=0.00..926.51 rows=16,110 width=0) (actual rows= loops=)

  • Index Cond: ((trip_summary_id)::text = ANY ((($1)::character varying[])::text[]))