explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yBcS

Settings
# exclusive inclusive rows x rows loops node
1. 0.153 12.004 ↑ 1.0 1 1

Hash Join (cost=240.72..869.82 rows=1 width=8) (actual time=11.479..12.004 rows=1 loops=1)

  • Hash Cond: (storekeeper.order_id = corde.order_id)
2. 0.407 0.407 ↑ 2.9 259 1

Index Scan using order_storekeepers_storekeeper_id_index on order_storekeepers storekeeper (cost=0.43..626.66 rows=764 width=8) (actual time=0.019..0.407 rows=259 loops=1)

  • Index Cond: (storekeeper_id = 95216)
  • Filter: (is_current IS TRUE)
  • Rows Removed by Filter: 5
3. 2.587 11.444 ↓ 1.3 4,537 1

Hash (cost=196.28..196.28 rows=3,520 width=4) (actual time=11.444..11.444 rows=4,537 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 224kB
4. 8.857 8.857 ↓ 1.3 4,537 1

Index Scan using orders_is_active_index on orders corde (cost=0.44..196.28 rows=3,520 width=4) (actual time=0.019..8.857 rows=4,537 loops=1)

  • Index Cond: (is_active = true)
  • Filter: (is_active IS TRUE)