explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dSLl

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 11,333.324 ↑ 1.0 45 1

Limit (cost=1,001.46..265,863.01 rows=45 width=294) (actual time=5,215.357..11,333.324 rows=45 loops=1)

2. 0.000 11,333.300 ↑ 14.8 45 1

Gather Merge (cost=1,001.46..3,920,952.44 rows=666 width=294) (actual time=5,215.355..11,333.300 rows=45 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 3.890 30,971.700 ↑ 15.4 18 3

Nested Loop (cost=1.44..3,919,875.54 rows=278 width=294) (actual time=2,562.224..10,323.900 rows=18 loops=3)

  • Join Filter: (teaser.id = teaser_country_relation.teaser_id)
4. 16.445 30,957.810 ↑ 17.1 333 3

Nested Loop (cost=0.87..3,884,992.89 rows=5,703 width=302) (actual time=55.897..10,319.270 rows=333 loops=3)

5. 30,877.224 30,877.224 ↑ 9.7 3,054 3

Parallel Index Scan Backward using teaser_created_at on teaser (cost=0.43..3,787,907.95 rows=29,718 width=294) (actual time=8.191..10,292.408 rows=3,054 loops=3)

  • Filter: ((clicks >= '0'::bigint) AND (clicks <= '4000000'::bigint) AND (to_tsvector('russian'::regconfig, (title)::text) @@ plainto_tsquery('open'::text)))
  • Rows Removed by Filter: 621237
6. 64.141 64.141 ↓ 0.0 0 9,163

Index Only Scan using idx_16506_idx_teaser_network_relation_temp_teaser_id_network_id on teaser_network_relation (cost=0.43..3.26 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=9,163)

  • Index Cond: (teaser_id = teaser.id)
  • Filter: (network_id = ANY ('{26,6}'::bigint[]))
  • Rows Removed by Filter: 1
  • Heap Fetches: 9206
7. 10.000 10.000 ↓ 0.0 0 1,000

Index Only Scan using idx_16500_idx_teaser_country_relation_temp_teaser_id_country_id on teaser_country_relation (cost=0.57..6.09 rows=2 width=8) (actual time=0.010..0.010 rows=0 loops=1,000)

  • Index Cond: ((teaser_id = teaser_network_relation.teaser_id) AND (country_id = ANY ('{4,67}'::bigint[])))
  • Heap Fetches: 55
Planning time : 1.337 ms
Execution time : 11,333.410 ms