explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H244

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 299.711 ↑ 1.0 45 1

Limit (cost=1,001.46..302,382.24 rows=45 width=180) (actual time=21.579..299.711 rows=45 loops=1)

2. 0.000 299.689 ↑ 2.4 45 1

Gather Merge (cost=1,001.46..710,920.64 rows=106 width=180) (actual time=21.578..299.689 rows=45 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.816 704.601 ↑ 2.6 17 3

Nested Loop (cost=1.44..709,908.38 rows=44 width=180) (actual time=7.675..234.867 rows=17 loops=3)

  • Join Filter: (teaser.id = teaser_country_relation.teaser_id)
4. 1.085 700.782 ↑ 9.4 91 3

Nested Loop (cost=0.87..701,820.68 rows=852 width=188) (actual time=2.395..233.594 rows=91 loops=3)

5. 687.327 687.327 ↑ 3.3 825 3

Parallel Index Scan Backward using teaser_created_at on teaser (cost=0.43..680,201.54 rows=2,728 width=180) (actual time=0.090..229.109 rows=825 loops=3)

  • Filter: ((clicks >= '180000'::bigint) AND (clicks <= '510000'::bigint))
  • Rows Removed by Filter: 875975
6. 12.370 12.370 ↓ 0.0 0 2,474

Index Only Scan using idx_16506_idx_teaser_network_relation_temp_teaser_id_network_id on teaser_network_relation (cost=0.43..7.91 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=2,474)

  • Index Cond: (teaser_id = teaser.id)
  • Filter: (network_id = ANY ('{4,3}'::bigint[]))
  • Rows Removed by Filter: 1
  • Heap Fetches: 2722
7. 3.003 3.003 ↓ 0.0 0 273

Index Only Scan using idx_16500_idx_teaser_country_relation_temp_teaser_id_country_id on teaser_country_relation (cost=0.57..9.47 rows=2 width=8) (actual time=0.011..0.011 rows=0 loops=273)

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