explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vohf : desc

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 8,513.314 ↑ 1.0 45 1

Limit (cost=1.44..51,442.72 rows=45 width=680) (actual time=8,511.577..8,513.314 rows=45 loops=1)

2. 175.689 8,513.309 ↑ 1,203.6 45 1

Nested Loop (cost=1.44..61,917,014.97 rows=54,164 width=680) (actual time=8,511.577..8,513.309 rows=45 loops=1)

3. 0.000 7,898.528 ↑ 1.2 439,092 1

Nested Loop (cost=0.87..26,035,822.80 rows=517,834 width=684) (actual time=1,056.707..7,898.528 rows=439,092 loops=1)

4. 2,136.442 2,136.442 ↑ 1.2 3,296,287 1

Index Scan Backward using "idx-teaser-created_at" on teaser (cost=0.43..10,414,778.50 rows=3,948,892 width=680) (actual time=1,056.421..2,136.442 rows=3,296,287 loops=1)

  • Filter: ((clicks >= 0) AND (clicks <= 4000000))
  • Rows Removed by Filter: 3999999
5. 6,592.574 6,592.574 ↓ 0.0 0 3,296,287

Index Scan using "idx-teaser_network_relation-teaser_id" on teaser_network_relation (cost=0.43..3.95 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=3,296,287)

  • Index Cond: (teaser_id = teaser.id)
  • Filter: (network_id = 7)
  • Rows Removed by Filter: 2
6. 439.092 439.092 ↓ 0.0 0 439,092

Index Scan using "idx-teaser_country_relation-teaser_id" on teaser_country_relation (cost=0.57..69.10 rows=19 width=4) (actual time=0.001..0.001 rows=0 loops=439,092)

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