explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1BME

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 15,385.961 ↑ 1.0 45 1

Limit (cost=907.12..14,162.55 rows=45 width=680) (actual time=15,383.956..15,385.961 rows=45 loops=1)

  • Planning time: 4.091 ms
  • Execution time: 15386.029 ms
2. 14.806 15,385.957 ↑ 229.5 45 1

Merge Join (cost=907.12..3,042,880.51 rows=10,327 width=680) (actual time=15,383.954..15,385.957 rows=45 loops=1)

  • Merge Cond: (teaser_network_relation.teaser_id = teaser.id)
3. 97.084 15,290.415 ↑ 4.6 85,134 1

Merge Join (cost=694.35..2,764,386.45 rows=390,599 width=8) (actual time=0.855..15,290.415 rows=85,134 loops=1)

  • Merge Cond: (teaser_network_relation.teaser_id = teaser_country_relation.teaser_id)
4. 136.434 136.434 ↑ 43.8 48,262 1

Index Scan using "idx-teaser_network_relation-teaser_id" on teaser_network_relation (cost=0.43..541,976.10 rows=2,111,479 width=4) (actual time=0.008..136.434 rows=48,262 loops=1)

  • Filter: (network_id = ANY ('{13,3}'::integer[]))
  • Rows Removed by Filter: 312025
5. 15,056.897 15,056.897 ↑ 2.5 323,560 1

Index Scan using "idx-teaser_country_relation-teaser_id" on teaser_country_relation (cost=0.57..2,705,912.58 rows=820,186 width=4) (actual time=0.575..15,056.897 rows=323,560 loops=1)

  • Filter: (country_id = ANY ('{3,67}'::integer[]))
  • Rows Removed by Filter: 56833284
6. 80.736 80.736 ↑ 2,478.3 154 1

Index Scan using teaser_pkey on teaser (cost=0.43..442,873.41 rows=381,657 width=680) (actual time=80.226..80.736 rows=154 loops=1)

  • Filter: ((clicks >= 180000) AND (clicks <= 510000))
  • Rows Removed by Filter: 179999