explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0rq

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.112 ↑ 3.7 3 1

Append (cost=4.49..85.63 rows=11 width=501) (actual time=0.043..0.112 rows=3 loops=1)

2. 0.022 0.047 ↑ 2.7 3 1

Bitmap Heap Scan on search_detail_p2019_06_06_0700 (cost=4.49..40.11 rows=8 width=537) (actual time=0.042..0.047 rows=3 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))))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=4
3. 0.025 0.025 ↑ 2.2 4 1

Bitmap Index Scan on search_detail_p2019_06_06_0700_idx (cost=0.00..4.49 rows=9 width=0) (actual time=0.025..0.025 rows=4 loops=1)

  • Index Cond: (sid = 'ef8f97d488aaf86bdab0e487aeb3b9e3'::text)
4. 0.001 0.061 ↓ 0.0 0 1

Bitmap Heap Scan on search_detail_p2019_06_06_0800 (cost=4.48..35.92 rows=2 width=541) (actual time=0.061..0.061 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.060 0.060 ↓ 0.0 0 1

Bitmap Index Scan on search_detail_p2019_06_06_0800_idx (cost=0.00..4.48 rows=8 width=0) (actual time=0.060..0.060 rows=0 loops=1)

  • Index Cond: (sid = 'ef8f97d488aaf86bdab0e487aeb3b9e3'::text)
6. 0.000 0.003 ↓ 0.0 0 1

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

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

  • Index Cond: (sid = 'ef8f97d488aaf86bdab0e487aeb3b9e3'::text)
Planning time : 160.677 ms
Execution time : 0.247 ms