explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vwHq : Optimization for: plan #6MqY

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.566 650.348 ↑ 2.0 5 1

Gather (cost=1,000.00..86,966.52 rows=10 width=8) (actual time=9.481..650.348 rows=5 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
2. 0.004 649.782 ↓ 1.2 5 1

Append (cost=0.00..85,965.52 rows=4 width=8) (actual time=9.040..649.782 rows=5 loops=1)

3. 500.954 500.954 ↓ 2.5 5 1

Parallel Seq Scan on _hyper_1_4_chunk payment0 (cost=0.00..57,433.67 rows=2 width=8) (actual time=9.040..500.954 rows=5 loops=1)

  • Filter: (pkey_pb = ANY ('{3022960862,3022960863,3022960864,3022960865,3022960866}'::bigint[]))
  • Rows Removed by Filter: 1367387
4. 148.824 148.824 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_5_chunk payment0_1 (cost=0.00..28,531.85 rows=2 width=8) (actual time=148.824..148.824 rows=0 loops=1)

  • Filter: (pkey_pb = ANY ('{3022960862,3022960863,3022960864,3022960865,3022960866}'::bigint[]))
  • Rows Removed by Filter: 632608
Planning time : 0.845 ms
Execution time : 650.388 ms