explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fimm

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 845.227 ↑ 1.0 45 1

Limit (cost=1,001.46..55,148.57 rows=45 width=680) (actual time=842.407..845.227 rows=45 loops=1)

  • Buffers: shared hit=41189 read=203306
2. 0.000 845.215 ↑ 210.9 45 1

Gather Merge (cost=1,001.46..11,418,822.91 rows=9,489 width=680) (actual time=842.404..845.215 rows=45 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=41189 read=203306
3. 0.093 2,520.609 ↑ 92.0 43 3

Nested Loop (cost=1.44..11,416,727.62 rows=3,954 width=680) (actual time=838.995..840.203 rows=43 loops=3)

  • Join Filter: (teaser.id = teaser_country_relation.teaser_id)
  • Buffers: shared hit=41189 read=203306
4. 0.279 2,518.500 ↑ 968.7 37 3

Nested Loop (cost=0.87..9,283,506.01 rows=35,843 width=684) (actual time=838.954..839.500 rows=37 loops=3)

  • Buffers: shared hit=40711 read=203182
5. 2,516.865 2,516.865 ↑ 908.8 151 3

Parallel Index Scan Backward using "idx-teaser-created_at" on teaser (cost=0.43..8,814,872.69 rows=137,224 width=680) (actual time=838.884..838.955 rows=151 loops=3)

  • Filter: ((clicks >= 180000) AND (clicks <= 510000))
  • Rows Removed by Filter: 2496666
  • Buffers: shared hit=38910 read=203166
6. 1.356 1.356 ↓ 0.0 0 452

Index Scan using "idx-teaser_network_relation-teaser_id" on teaser_network_relation (cost=0.43..3.41 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=452)

  • Index Cond: (teaser_id = teaser.id)
  • Filter: (network_id = ANY ('{13,3}'::integer[]))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=1801 read=16
7. 2.016 2.016 ↑ 20.0 1 112

Index Scan using "idx-teaser_country_relation-teaser_id" on teaser_country_relation (cost=0.57..59.27 rows=20 width=4) (actual time=0.008..0.018 rows=1 loops=112)

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