explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tOew

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=113,294.09..10,962,824.33 rows=10,765 width=68) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=113,293.66..10,884,262.02 rows=10,765 width=8) (actual rows= loops=)

  • Workers Planned: 3
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=112,293.66..10,882,185.52 rows=3,473 width=8) (actual rows= loops=)

  • Hash Cond: (function_instance.file_instance_id = file_instance.id)
4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on function_instance (cost=0.00..10,541,220.27 rows=60,969,827 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=112,213.38..112,213.38 rows=6,423 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.88..112,213.38 rows=6,423 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on snapshot_element (cost=4.31..15.84 rows=1 width=8) (actual rows= loops=)

  • Recheck Cond: (snapshot_id = 15553)
  • Filter: ((dtype)::text = 'SrcSE'::text)
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on snpsht_el_snpsht_idx (cost=0.00..4.31 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (snapshot_id = 15553)
9. 0.000 0.000 ↓ 0.0

Index Scan using file_inst_src_data_file_idx on file_instance (cost=0.57..111,885.32 rows=31,221 width=16) (actual rows= loops=)

  • Index Cond: (source_data_id = snapshot_element.id)
10. 0.000 0.000 ↓ 0.0

Index Scan using function_metrics_pkey on function_metrics (cost=0.42..7.30 rows=1 width=68) (actual rows= loops=)

  • Index Cond: (id = function_instance.function_metrics_id)