explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ca7g

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.150 ↑ 1.0 1 1

Nested Loop (cost=6.1..2,572.14 rows=1 width=4) (actual time=0.134..0.15 rows=1 loops=1)

2. 0.004 0.125 ↑ 7.5 8 1

Nested Loop (cost=5.68..2,437.44 rows=60 width=20) (actual time=0.026..0.125 rows=8 loops=1)

3. 0.032 0.045 ↑ 1.4 76 1

Bitmap Heap Scan on stores_customer stores_customer (cost=5.26..404.25 rows=108 width=4) (actual time=0.018..0.045 rows=76 loops=1)

4. 0.013 0.013 ↑ 1.4 76 1

Bitmap Index Scan on stores_customer_store_id_2dcc2358 (cost=0..5.23 rows=108 width=0) (actual time=0.012..0.013 rows=76 loops=1)

  • Index Cond: (store_id = 1)
5. 0.076 0.076 ↓ 0.0 0 76

Index Scan using reports_campaigntransmissionstats_customer_id_91799725 on reports_campaigncustomerstats reports_campaigncustomerstats (cost=0.42..18.81 rows=2 width=16) (actual time=0.001..0.001 rows=0 loops=76)

  • Index Cond: (customer_id = stores_customer.id)
  • Filter: ((click_events_count > 0) OR (initial_open_events_count > 0))
6. 0.024 0.024 ↓ 0.0 0 8

Index Scan using campaigns_campaignaudience_subscriber_id_59ff7dc2 on campaigns_campaignaudience campaigns_campaignaudience (cost=0.43..2.23 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=8)

  • Index Cond: (subscriber_id = reports_campaigncustomerstats.customer_id)
  • Filter: ((reports_campaigncustomerstats.campaign_id = campaign_id) AND ((send_time > '2019-04-04 13:19:45.202001+03'::timestamp with time zone) OR (send_time > '2019-07-04 13:19:45.202001+03'::timestamp with time zone)) AND (((reports_campaigncustomerstats.click_events_count > 0) AND (send_time > '2019-04-04 13:19:45.202001+03'::timestamp with time zone)) OR ((reports_campaigncustomerstats.initial_open_events_count > 0) AND (send_time > '2019-07-04 13:19:45.202001+03'::timestamp with time zone))))