explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ypxL

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

Seq Scan on trip_summary_coupon (cost=8.58..11,360,505.43 rows=1,611 width=940) (actual rows= loops=)

  • Filter: ((trip_summary_id)::bpchar = $0)
2.          

Initplan (for Seq Scan)

3. 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))