explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6cnh

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

Append (cost=4.50..70.24 rows=10 width=500) (actual time=0.084..0.101 rows=3 loops=1)

2. 0.004 0.041 ↓ 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.041..0.041 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.037 0.037 ↓ 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.037..0.037 rows=0 loops=1)

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

Index Scan using idx_temp_test on search_detail_p2019_06_05_0300 (cost=0.42..16.53 rows=3 width=533) (actual time=0.042..0.053 rows=3 loops=1)

  • Index Cond: ((sid = 'ea9eef3150c6a96f8c13066f040f0a28'::text) AND (datetime >= '2019-06-05 02:48:12'::timestamp without time zone) AND (datetime <= '2019-06-05 03:18:12'::timestamp without time zone))
  • Filter: ((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.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on search_detail_default (cost=4.16..9.54 rows=1 width=137) (actual time=0.004..0.004 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.004 0.004 ↓ 0.0 0 1

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

  • Index Cond: (sid = 'ea9eef3150c6a96f8c13066f040f0a28'::text)
Planning time : 72.723 ms
Execution time : 0.327 ms