explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NqLX : q1

Settings
# exclusive inclusive rows x rows loops node
1. 0.405 130,363.728 ↑ 744.4 23 1

GroupAggregate (cost=805,625.04..806,224.31 rows=17,122 width=46) (actual time=130,363.089..130,363.728 rows=23 loops=1)

  • Group Key: ddb.abm_id, dfa.placement_type, dfa.geo_country
2. 0.769 130,363.323 ↑ 51.9 330 1

Sort (cost=805,625.04..805,667.85 rows=17,122 width=22) (actual time=130,363.044..130,363.323 rows=330 loops=1)

  • Sort Key: ddb.abm_id, dfa.placement_type, dfa.geo_country
  • Sort Method: quicksort Memory: 50kB
3. 929.007 130,362.554 ↑ 51.9 330 1

Merge Join (cost=800,414.20..804,421.06 rows=17,122 width=22) (actual time=128,411.812..130,362.554 rows=330 loops=1)

  • Merge Cond: (ddb.abm_id = dfa.abm_id)
4. 0.057 11.665 ↑ 302.4 19 1

Group (cost=17,493.69..17,522.42 rows=5,745 width=4) (actual time=11.582..11.665 rows=19 loops=1)

  • Group Key: ddb.abm_id
5. 0.070 11.608 ↑ 302.4 19 1

Sort (cost=17,493.69..17,508.05 rows=5,745 width=4) (actual time=11.580..11.608 rows=19 loops=1)

  • Sort Key: ddb.abm_id
  • Sort Method: quicksort Memory: 25kB
6. 0.099 11.538 ↑ 302.4 19 1

Nested Loop (cost=1.69..17,134.97 rows=5,745 width=4) (actual time=3.524..11.538 rows=19 loops=1)

7. 0.127 9.843 ↑ 302.4 19 1

Nested Loop (cost=1.13..13,607.82 rows=5,745 width=18) (actual time=3.492..9.843 rows=19 loops=1)

8. 2.857 2.857 ↑ 302.4 19 1

Index Scan using index_list_domains_on_list_id_and_hidden_and_dynamic_hidden_new on list_domains ld (cost=0.57..3,988.97 rows=5,745 width=15) (actual time=2.798..2.857 rows=19 loops=1)

  • Index Cond: ((list_id = 196572) AND (hidden = false) AND (dynamic_hidden = false))
  • Filter: ((NOT hidden) AND (NOT dynamic_hidden))
9. 6.859 6.859 ↑ 1.0 1 19

Index Only Scan using domaindb_domain_aliases_tmp_given_domain_domaindb_domain_idx on domaindb_domain_aliases ddba (cost=0.56..1.66 rows=1 width=36) (actual time=0.360..0.361 rows=1 loops=19)

  • Index Cond: (given_domain = ld.given_domain)
  • Heap Fetches: 0
10. 1.596 1.596 ↑ 1.0 1 19

Index Scan using domaindb_tmp_domain_idx1 on domaindb ddb (cost=0.56..0.60 rows=1 width=22) (actual time=0.083..0.084 rows=1 loops=19)

  • Index Cond: ((domain)::text = (ddba.domaindb_domain)::text)
11. 2,673.017 129,421.882 ↓ 1.4 1,058,862 1

Sort (cost=782,920.51..784,788.06 rows=747,021 width=22) (actual time=128,331.695..129,421.882 rows=1,058,862 loops=1)

  • Sort Key: dfa.abm_id
  • Sort Method: quicksort Memory: 114758kB
12. 126,748.865 126,748.865 ↓ 1.4 1,081,724 1

Index Scan using idx_dsp_delivery_forecast_aggregates_geo_country on dsp_delivery_forecast_aggregates dfa (cost=0.56..710,045.66 rows=747,021 width=22) (actual time=3.577..126,748.865 rows=1,081,724 loops=1)

  • Index Cond: ((geo_country)::text = ANY ('{deu,che,lux,aut}'::text[]))
  • Filter: (((placement_type)::text = ANY ('{banner}'::text[])) AND (((placement_type)::text <> 'banner'::text) OR ((banner_dimensions)::text = ANY ('{160x600,300x250,300x50,300x600,320x50,728x90,970x250}'::text[]))))
  • Rows Removed by Filter: 751099