explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9UUB

Settings
# exclusive inclusive rows x rows loops node
1. 1,380.947 2,157.312 ↓ 1.3 666 1

HashAggregate (cost=137,359.380..137,364.350 rows=497 width=12) (actual time=2,157.228..2,157.312 rows=666 loops=1)

  • Output: alpha(romeo_hotel), oscar
  • Group Key: india.oscar
  • Buffers: shared hit=16105 read=45701
2. 776.365 776.365 ↑ 1.0 5,036,817 1

Seq Scan on november (cost=0.000..112,174.920 rows=5,036,892 width=12) (actual time=0.014..776.365 rows=5,036,817 loops=1)

  • Output: quebec, oscar, romeo_hotel, lima, two, sierra, juliet, romeo_alpha, xray_india, echo, xray_echo, yankee
  • Buffers: shared hit=16105 read=45701
Planning time : 8.194 ms
Execution time : 2,157.401 ms