explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nxR8

Settings
# exclusive inclusive rows x rows loops node
1. 5.891 24.538 ↑ 1.0 3,719 1

Sort (cost=2,904.78..2,914.17 rows=3,757 width=110) (actual time=24.403..24.538 rows=3,719 loops=1)

  • Sort Key: stop_2019_12.stop_location_id
  • Sort Method: quicksort Memory: 949kB
2. 6.227 18.647 ↑ 1.0 3,719 1

Hash Semi Join (cost=564.94..2,681.70 rows=3,757 width=110) (actual time=7.913..18.647 rows=3,719 loops=1)

  • Hash Cond: ((stop_2019_12.id)::text = ("ANY_subquery".stop_id)::text)
3. 4.536 4.536 ↑ 1.0 59,840 1

Seq Scan on stop_2019_12 (cost=0.00..1,718.40 rows=59,840 width=110) (actual time=0.010..4.536 rows=59,840 loops=1)

4. 0.369 7.884 ↑ 1.0 4,103 1

Hash (cost=513.64..513.64 rows=4,104 width=6) (actual time=7.884..7.884 rows=4,103 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 154kB
5. 0.260 7.515 ↑ 1.0 4,104 1

Subquery Scan on ANY_subquery (cost=462.34..513.64 rows=4,104 width=6) (actual time=7.135..7.515 rows=4,104 loops=1)

6. 6.729 7.255 ↑ 1.0 4,104 1

Sort (cost=462.34..472.60 rows=4,104 width=13) (actual time=7.135..7.255 rows=4,104 loops=1)

  • Sort Key: smart_stop.id
  • Sort Method: quicksort Memory: 385kB
7. 0.526 0.526 ↑ 1.0 4,104 1

Seq Scan on smart_stop (cost=0.00..216.04 rows=4,104 width=13) (actual time=0.002..0.526 rows=4,104 loops=1)

Total runtime : 24.619 ms