explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lxRJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 11.215 ↑ 1.0 45 1

Limit (cost=1,001.46..30,469.41 rows=45 width=744) (actual time=4.166..11.215 rows=45 loops=1)

2. 0.000 11.204 ↑ 1,274.4 45 1

Gather Merge (cost=1,001.46..37,556,263.48 rows=57,350 width=744) (actual time=4.164..11.204 rows=45 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.055 11.898 ↑ 569.0 42 3

Nested Loop (cost=1.44..37,548,643.84 rows=23,896 width=744) (actual time=0.076..3.966 rows=42 loops=3)

4. 0.198 1.779 ↑ 9,402.5 23 3

Nested Loop (cost=0.87..22,994,466.17 rows=216,257 width=748) (actual time=0.054..0.593 rows=23 loops=3)

5. 0.273 0.273 ↑ 11,476.9 145 3

Parallel Index Scan Backward using "idx-teaser-created_at" on teaser (cost=0.43..15,799,794.93 rows=1,664,152 width=744) (actual time=0.020..0.091 rows=145 loops=3)

  • Filter: ((clicks >= 0) AND (clicks <= 4000000))
  • Rows Removed by Filter: 1
6. 1.308 1.308 ↓ 0.0 0 436

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

  • Index Cond: (teaser_id = teaser.id)
  • Filter: (network_id = 7)
  • Rows Removed by Filter: 2
7. 10.064 10.064 ↑ 10.0 2 68

Index Scan using "idx-teaser_country_relation-teaser_id" on teaser_country_relation (cost=0.57..67.10 rows=20 width=4) (actual time=0.010..0.148 rows=2 loops=68)

  • Index Cond: (teaser_id = teaser.id)
  • Filter: (country_id = ANY ('{3,67}'::integer[]))
  • Rows Removed by Filter: 398