explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TKO4

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.059 ↑ 3.3 3 1

Append (cost=0.42..25.84 rows=10 width=499) (actual time=0.038..0.059 rows=3 loops=1)

2. 0.042 0.042 ↑ 2.3 3 1

Index Scan using search_detail_p2019_06_06_0700_idx on search_detail_p2019_06_06_0700 (cost=0.42..11.75 rows=7 width=539) (actual time=0.038..0.042 rows=3 loops=1)

  • Index Cond: (sid = 'ef8f97d488aaf86bdab0e487aeb3b9e3'::text)
  • Filter: ((datetime >= '2019-06-06 07:31:34'::timestamp without time zone) AND (datetime <= '2019-06-06 08:01:34'::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
3. 0.011 0.011 ↓ 0.0 0 1

Index Scan using search_detail_p2019_06_06_0800_idx on search_detail_p2019_06_06_0800 (cost=0.42..10.61 rows=2 width=538) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (sid = 'ef8f97d488aaf86bdab0e487aeb3b9e3'::text)
  • Filter: ((datetime >= '2019-06-06 07:31:34'::timestamp without time zone) AND (datetime <= '2019-06-06 08:01:34'::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))))
4. 0.002 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on search_detail_default (cost=1.26..3.44 rows=1 width=137) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (sid = 'ef8f97d488aaf86bdab0e487aeb3b9e3'::text)
  • Filter: ((datetime >= '2019-06-06 07:31:34'::timestamp without time zone) AND (datetime <= '2019-06-06 08:01:34'::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))))
5. 0.003 0.003 ↓ 0.0 0 1

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

  • Index Cond: (sid = 'ef8f97d488aaf86bdab0e487aeb3b9e3'::text)
Planning time : 47.313 ms
Execution time : 0.154 ms