explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z6yk

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 757.434 ↑ 1.0 45 1

Limit (cost=1,001.46..55,352.80 rows=45 width=680) (actual time=713.953..757.434 rows=45 loops=1)

  • Buffers: shared hit=244331
2. 0.000 757.424 ↑ 209.8 45 1

Gather Merge (cost=1,001.46..11,406,328.22 rows=9,443 width=680) (actual time=713.951..757.424 rows=45 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=244331
3. 0.111 2,133.486 ↑ 89.4 44 3

Nested Loop (cost=1.44..11,404,238.24 rows=3,935 width=680) (actual time=710.071..711.162 rows=44 loops=3)

  • Join Filter: (teaser.id = teaser_country_relation.teaser_id)
  • Buffers: shared hit=244331
4. 0.006 2,131.620 ↑ 914.5 39 3

Nested Loop (cost=0.87..9,281,491.40 rows=35,667 width=684) (actual time=710.052..710.540 rows=39 loops=3)

  • Buffers: shared hit=243703
5. 2,130.207 2,130.207 ↑ 875.3 156 3

Parallel Index Scan Backward using "idx-teaser-created_at" on teaser (cost=0.43..8,814,732.45 rows=136,549 width=680) (actual time=710.018..710.069 rows=156 loops=3)

  • Filter: ((clicks >= 180000) AND (clicks <= 510000))
  • Rows Removed by Filter: 2496666
  • Buffers: shared hit=241818
6. 1.407 1.407 ↓ 0.0 0 469

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=469)

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

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.005..0.015 rows=1 loops=117)

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