explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3lHx

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 2,155.591 ↑ 1.0 45 1

Limit (cost=1.44..72,191.04 rows=45 width=680) (actual time=2,154.747..2,155.591 rows=45 loops=1)

  • Buffers: shared hit=21378 read=203212
2. 0.007 2,155.586 ↑ 229.5 45 1

Nested Loop (cost=1.44..16,566,714.19 rows=10,327 width=680) (actual time=2,154.746..2,155.586 rows=45 loops=1)

  • Join Filter: (teaser.id = teaser_country_relation.teaser_id)
  • Buffers: shared hit=21378 read=203212
3. 0.000 2,155.111 ↑ 2,582.9 39 1

Nested Loop (cost=0.87..10,154,734.34 rows=100,733 width=684) (actual time=2,154.719..2,155.111 rows=39 loops=1)

  • Buffers: shared hit=21222 read=203162
4. 2,154.755 2,154.755 ↑ 2,008.7 190 1

Index Scan Backward using "idx-teaser-created_at" on teaser (cost=0.43..8,884,728.41 rows=381,657 width=680) (actual time=2,154.690..2,154.755 rows=190 loops=1)

  • Filter: ((clicks >= 180000) AND (clicks <= 510000))
  • Rows Removed by Filter: 7489999
  • Buffers: shared hit=20466 read=203155
5. 0.380 0.380 ↓ 0.0 0 190

Index Scan using "idx-teaser_network_relation-teaser_id" on teaser_network_relation (cost=0.43..3.32 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=190)

  • Index Cond: (teaser_id = teaser.id)
  • Filter: (network_id = ANY ('{13,3}'::integer[]))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=756 read=7
6. 0.468 0.468 ↑ 19.0 1 39

Index Scan using "idx-teaser_country_relation-teaser_id" on teaser_country_relation (cost=0.57..63.42 rows=19 width=4) (actual time=0.010..0.012 rows=1 loops=39)

  • Index Cond: (teaser_id = teaser_network_relation.teaser_id)
  • Filter: (country_id = ANY ('{3,67}'::integer[]))
  • Rows Removed by Filter: 41
  • Buffers: shared hit=156 read=50