explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GZYB

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.301 ↑ 3.3 3 1

Append (cost=4.50..102.53 rows=10 width=500) (actual time=0.221..0.301 rows=3 loops=1)

2. 0.003 0.104 ↓ 0.0 0 1

Bitmap Heap Scan on search_detail_p2019_06_05_0200 (cost=4.50..44.11 rows=6 width=544) (actual time=0.104..0.104 rows=0 loops=1)

  • Recheck Cond: (sid = 'ea9eef3150c6a96f8c13066f040f0a28'::text)
  • Filter: ((datetime >= '2019-06-05 02:48:12'::timestamp without time zone) AND (datetime <= '2019-06-05 03:18:12'::timestamp without time zone) AND ((event_type = ANY ('{ae_filter_out_json_response,raw_travelport_parser,raw_tripstack_response,sysrate_filter_out_response,sysrate_final_response}'::text[])) OR ((event_type = 'ae_final_response'::text) AND ((metadata ->> 'status'::text) = 'Completed'::text))))
3. 0.101 0.101 ↓ 0.0 0 1

Bitmap Index Scan on search_detail_p2019_06_05_0200_idx (cost=0.00..4.50 rows=10 width=0) (actual time=0.101..0.101 rows=0 loops=1)

  • Index Cond: (sid = 'ea9eef3150c6a96f8c13066f040f0a28'::text)
4. 0.184 0.184 ↑ 1.0 3 1

Index Scan using search_detail_p2019_06_05_0300_idx on search_detail_p2019_06_05_0300 (cost=0.42..48.82 rows=3 width=533) (actual time=0.116..0.184 rows=3 loops=1)

  • Index Cond: (sid = 'ea9eef3150c6a96f8c13066f040f0a28'::text)
  • Filter: ((datetime >= '2019-06-05 02:48:12'::timestamp without time zone) AND (datetime <= '2019-06-05 03:18:12'::timestamp without time zone) AND ((event_type = ANY ('{ae_filter_out_json_response,raw_travelport_parser,raw_tripstack_response,sysrate_filter_out_response,sysrate_final_response}'::text[])) OR ((event_type = 'ae_final_response'::text) AND ((metadata ->> 'status'::text) = 'Completed'::text))))
  • Rows Removed by Filter: 1
5. 0.001 0.010 ↓ 0.0 0 1

Bitmap Heap Scan on search_detail_default (cost=4.16..9.54 rows=1 width=137) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: (sid = 'ea9eef3150c6a96f8c13066f040f0a28'::text)
  • Filter: ((datetime >= '2019-06-05 02:48:12'::timestamp without time zone) AND (datetime <= '2019-06-05 03:18:12'::timestamp without time zone) AND ((event_type = ANY ('{ae_filter_out_json_response,raw_travelport_parser,raw_tripstack_response,sysrate_filter_out_response,sysrate_final_response}'::text[])) OR ((event_type = 'ae_final_response'::text) AND ((metadata ->> 'status'::text) = 'Completed'::text))))
6. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on search_detail_default_idx (cost=0.00..4.16 rows=2 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (sid = 'ea9eef3150c6a96f8c13066f040f0a28'::text)
Planning time : 941.492 ms
Execution time : 0.572 ms