explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 28r4

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 47.849 ↑ 1,776.0 1 1

Nested Loop (cost=1,000.56..9,475.68 rows=1,776 width=22) (actual time=36.658..47.849 rows=1 loops=1)

2. 0.012 0.012 ↑ 1.0 1 1

Index Only Scan using geotadilat_objectid_uniq on geotadilat (cost=0.27..4.29 rows=1 width=4) (actual time=0.009..0.012 rows=1 loops=1)

  • Index Cond: (objectid = 1)
  • Heap Fetches: 0
3. 36.088 49.269 ↑ 1,776.0 1 1

Gather (cost=1,000.29..9,453.63 rows=1,776 width=26) (actual time=36.646..49.269 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.004 13.181 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.29..8,276.03 rows=740 width=26) (actual time=12.714..13.181 rows=0 loops=3)

5. 13.173 13.173 ↓ 0.0 0 3 / 3

Parallel Seq Scan on pys_parsel_tadilat_yedek (cost=0.00..5,402.00 rows=740 width=12) (actual time=12.707..13.173 rows=0 loops=3)

  • Filter: (tadilat_id = 1)
  • Rows Removed by Filter: 30,557
6. 0.004 0.004 ↑ 1.0 1 1 / 3

Index Scan using idx_parsel_objectid on parsel (cost=0.29..3.88 rows=1 width=18) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (objectid = pys_parsel_tadilat_yedek.parsel_id)
Planning time : 0.772 ms
Execution time : 49.333 ms