explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wegp

Settings
# exclusive inclusive rows x rows loops node
1. 0.761 67.798 ↑ 125.4 32 1

Hash Join (cost=2,356.77..5,610.67 rows=4,012 width=316) (actual time=67.641..67.798 rows=32 loops=1)

  • Hash Cond: (c.movie_id = m.id)
  • Buffers: shared hit=6 read=1344
2. 0.016 0.417 ↑ 125.4 32 1

Nested Loop (cost=0.84..3,244.21 rows=4,012 width=112) (actual time=0.278..0.417 rows=32 loops=1)

  • Buffers: shared hit=3 read=26
3. 0.160 0.160 ↑ 1.0 1 1

Index Scan using people_pkey on people p (cost=0.42..2.46 rows=1 width=52) (actual time=0.160..0.160 rows=1 loops=1)

  • Index Cond: (id = 4111)
  • Buffers: shared hit=3 read=4
4. 0.241 0.241 ↑ 125.4 32 1

Index Scan using casts_person_id_idx on casts c (cost=0.42..3,201.64 rows=4,012 width=60) (actual time=0.109..0.241 rows=32 loops=1)

  • Index Cond: (person_id = 4111)
  • Buffers: shared read=22
5. 37.231 66.620 ↓ 2.4 109,482 1

Hash (cost=1,779.30..1,779.30 rows=46,130 width=204) (actual time=66.619..66.620 rows=109,482 loops=1)

  • Buckets: 131072 (originally 65536) Batches: 1 (originally 1) Memory Usage: 11429kB
  • Buffers: shared read=1318
6. 29.389 29.389 ↓ 2.4 109,482 1

Seq Scan on movies m (cost=0.00..1,779.30 rows=46,130 width=204) (actual time=0.040..29.389 rows=109,482 loops=1)

  • Buffers: shared read=1318
Planning time : 2.824 ms
Execution time : 68.057 ms