explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y5B

Settings
# exclusive inclusive rows x rows loops node
1. 0.489 408.799 ↓ 15.9 44,260 1

Nested Loop (cost=1,000.85..10,379.05 rows=2,776 width=568) (actual time=3.228..408.799 rows=44,260 loops=1)

2. 0.045 0.045 ↑ 1.0 1 1

Seq Scan on part1a p1a (cost=0.00..3.13 rows=1 width=100) (actual time=0.040..0.045 rows=1 loops=1)

  • Filter: (cat_id = 11432)
  • Rows Removed by Filter: 89
3. 46.894 408.265 ↓ 15.9 44,260 1

Gather (cost=1,000.85..10,348.16 rows=2,776 width=348) (actual time=3.183..408.265 rows=44,260 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 314.561 361.371 ↓ 13.6 22,130 2

Nested Loop Left Join (cost=0.85..9,070.56 rows=1,633 width=348) (actual time=1.214..361.371 rows=22,130 loops=2)

5. 36.948 46.797 ↓ 13.6 22,130 2

Nested Loop (cost=0.43..7,773.79 rows=1,633 width=341) (actual time=1.171..46.797 rows=22,130 loops=2)

6. 9.804 9.804 ↑ 1.2 496 2

Parallel Seq Scan on part1b p1b (cost=0.00..2,942.37 rows=584 width=219) (actual time=1.129..9.804 rows=496 loops=2)

  • Filter: (cat_id = 11432)
  • Rows Removed by Filter: 28157
7. 0.045 0.045 ↓ 45.0 45 992

Index Scan using europe_part2_cat_id_f1_f2_idx on part2 p (cost=0.43..8.26 rows=1 width=142) (actual time=0.009..0.045 rows=45 loops=992)

  • Index Cond: ((cat_id = 11432) AND (f1 = p1b.f1) AND (f2 = p1b.f2))
8. 0.013 0.013 ↑ 1.0 1 44,260

Index Scan using europe_finis_number_number_idx on finis_number s (cost=0.42..0.78 rows=1 width=20) (actual time=0.013..0.013 rows=1 loops=44,260)

  • Index Cond: (number = p.number2)
Planning time : 7.151 ms
Execution time : 429.101 ms