explain.depesz.com

PostgreSQL's explain analyze made readable

Result: weTp

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3,374.69..61,969.05 rows=1 width=30) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3,374.13..61,961.46 rows=1 width=33) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using rpa_entity_source_rank_idx on rpa_entity en2 (cost=0.29..7.88 rows=1 width=25) (actual rows= loops=)

  • Filter: ((entity_type = 'SRCE'::bpchar) AND ((data_value)::integer <= 2))
4. 0.000 0.000 ↓ 0.0

Append (cost=3,373.85..61,953.11 rows=47 width=30) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on rpa_event_2019_05 ev (cost=3,373.85..61,952.88 rows=47 width=30) (actual rows= loops=)

  • Recheck Cond: ((timestamp_utc >= en2.valid_from) AND (timestamp_utc <= en2.valid_to) AND (timestamp_utc >= '2019-05-01 00:00:00+00'::timestamp with time zone) AND (timestamp_utc < '2019-06-01 00:00:00+00'::timestamp with time zone))
  • Filter: ((event_sentiment_score IS NOT NULL) AND (relevance >= 100) AND ((topic_group)::text = 'earnings'::text) AND (en2.rp_entity_id = rp_source_id))
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on rpa_event_2019_05_timestamp_utc_idx (cost=0.00..3,373.84 rows=96,894 width=0) (actual rows= loops=)

  • Index Cond: ((timestamp_utc >= en2.valid_from) AND (timestamp_utc <= en2.valid_to) AND (timestamp_utc >= '2019-05-01 00:00:00+00'::timestamp with time zone) AND (timestamp_utc < '2019-06-01 00:00:00+00'::timestamp with time zone))
7. 0.000 0.000 ↓ 0.0

Index Scan using rpa_entity_unique_id_entity_type_data_type_value on rpa_entity en1 (cost=0.56..7.57 rows=1 width=25) (actual rows= loops=)

  • Index Cond: ((rp_entity_id = ev.rp_entity_id) AND (entity_type = 'COMP'::bpchar) AND ((data_type)::text = 'CUSIP'::text) AND (ev.timestamp_utc >= valid_from))
  • Filter: (ev.timestamp_utc <= valid_to)