explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZZKz

Settings
# exclusive inclusive rows x rows loops node
1. 5.791 23.129 ↑ 1.0 3,719 1

Sort (cost=2,812.78..2,822.17 rows=3,757 width=110) (actual time=22.987..23.129 rows=3,719 loops=1)

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

Hash Semi Join (cost=472.94..2,589.70 rows=3,757 width=110) (actual time=7.680..17.338 rows=3,719 loops=1)

  • Hash Cond: ((stop_2019_12.id)::text = ("ANY_subquery".stop_id)::text)
3. 3.519 3.519 ↑ 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.002..3.519 rows=59,840 loops=1)

4. 0.328 7.660 ↑ 1.0 4,103 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 154kB
5. 0.267 7.332 ↑ 1.0 4,104 1

Subquery Scan on ANY_subquery (cost=370.34..421.64 rows=4,104 width=6) (actual time=6.951..7.332 rows=4,104 loops=1)

6. 6.650 7.065 ↑ 1.0 4,104 1

Sort (cost=370.34..380.60 rows=4,104 width=13) (actual time=6.951..7.065 rows=4,104 loops=1)

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

Seq Scan on smart_stop_copy (cost=0.00..124.04 rows=4,104 width=13) (actual time=0.002..0.415 rows=4,104 loops=1)

Total runtime : 23.198 ms