explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iXL1

Settings
# exclusive inclusive rows x rows loops node
1. 110.190 7,953.283 ↓ 1.0 199,762 1

Unique (cost=256,825.09..257,934.55 rows=192,081 width=388) (actual time=7,303.891..7,953.283 rows=199,762 loops=1)

  • Buffers: shared hit=454172 read=48204, temp read=25676 written=26163
2. 1,990.487 7,843.093 ↓ 1.0 222,055 1

Sort (cost=256,825.09..257,379.82 rows=221,891 width=388) (actual time=7,303.889..7,843.093 rows=222,055 loops=1)

  • Sort Key: e."NUM_1", e.imported_from_ts DESC
  • Sort Method: external merge Disk: 45584kB
  • Buffers: shared hit=454172 read=48204, temp read=25676 written=26163
3. 116.652 5,852.606 ↓ 1.0 222,055 1

Gather (cost=64,697.96..158,245.74 rows=221,891 width=388) (actual time=3,080.68..5,852.606 rows=222,055 loops=1)

  • Buffers: shared hit=454172 read=48204, temp read=18913 written=19384
4. 2,762.531 5,735.954 ↑ 1.2 74,018 3

Hash Join (cost=63,697.96..135,056.64 rows=92,455 width=388) (actual time=3,075.048..5,735.954 rows=74,018 loops=3)

  • Buffers: shared hit=454172 read=48204, temp read=18913 written=19384
5. 58.320 58.320 ↑ 1.2 73,865 3

Seq Scan on TFS_EVENT_DATA e (cost=0..7,369.31 rows=92,331 width=125) (actual time=0.011..58.32 rows=73,865 loops=3)

  • Buffers: shared hit=6446
6. 316.649 2,915.103 ↑ 1.2 221,012 3

Hash (cost=54,038.65..54,038.65 rows=276,265 width=157) (actual time=2,915.102..2,915.103 rows=221,012 loops=3)

  • Buffers: shared hit=3072 read=48204, temp written=15064
7. 2,598.454 2,598.454 ↑ 1.2 221,012 3

Seq Scan on TFS_METRICS m (cost=0..54,038.65 rows=276,265 width=157) (actual time=0.012..2,598.454 rows=221,012 loops=3)

  • Buffers: shared hit=3072 read=48204
Planning time : 0.452 ms
Execution time : 8,087.961 ms