explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EeDQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.109 ↑ 3.3 3 1

Append (cost=4.50..68.88 rows=10 width=500) (actual time=0.086..0.109 rows=3 loops=1)

2. 0.009 0.046 ↓ 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.046..0.046 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.051 0.051 ↑ 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.039..0.051 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.010 0.010 ↓ 0.0 0 1

Index Scan using idx_temp_test1 on search_detail_default (cost=0.15..8.18 rows=1 width=137) (actual time=0.010..0.010 rows=0 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)))
Planning time : 69.672 ms
Execution time : 0.320 ms