explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wo9z

Settings
# exclusive inclusive rows x rows loops node
1. 2,624.487 16,655.570 ↑ 10,630.4 14 1

Hash Right Join (cost=30,229.58..1,268,599.00 rows=148,826 width=12) (actual time=10,473.999..16,655.570 rows=14 loops=1)

  • Hash Cond: (rp2.request_id = r.id)
2. 14,030.888 14,030.888 ↑ 1.0 18,158,250 1

Seq Scan on req_package2 rp2 (cost=0.00..1,168,607.40 rows=18,206,340 width=12) (actual time=0.018..14,030.888 rows=18,158,250 loops=1)

3. 0.025 0.195 ↑ 5,215.5 2 1

Hash (cost=30,099.19..30,099.19 rows=10,431 width=16) (actual time=0.194..0.195 rows=2 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 129kB
4. 0.016 0.170 ↑ 5,215.5 2 1

Nested Loop (cost=76.47..30,099.19 rows=10,431 width=16) (actual time=0.159..0.170 rows=2 loops=1)

5. 0.018 0.070 ↑ 1.0 3 1

HashAggregate (cost=9.10..9.13 rows=3 width=8) (actual time=0.067..0.070 rows=3 loops=1)

  • Group Key: ('57158160899'::bigint)
6. 0.004 0.052 ↑ 1.0 3 1

Append (cost=0.00..9.09 rows=3 width=8) (actual time=0.007..0.052 rows=3 loops=1)

7. 0.006 0.006 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=1)

8. 0.042 0.042 ↑ 1.0 2 1

Index Scan using aix_4b88b957d30c0f5b895f400847c002ef on booked_room_guest (cost=0.43..9.04 rows=2 width=8) (actual time=0.037..0.042 rows=2 loops=1)

  • Index Cond: (booked_room_id = '57158160899'::bigint)
9. 0.033 0.084 ↑ 3,477.0 1 3

Bitmap Heap Scan on request r (cost=67.37..9,995.24 rows=3,477 width=16) (actual time=0.025..0.028 rows=1 loops=3)

  • Recheck Cond: (payer_id = ('57158160899'::bigint))
  • Heap Blocks: exact=2
10. 0.051 0.051 ↑ 3,477.0 1 3

Bitmap Index Scan on aix_1b1aa0b2eae0ab01bc1ca657d36e4e65 (cost=0.00..66.50 rows=3,477 width=0) (actual time=0.017..0.017 rows=1 loops=3)

  • Index Cond: (payer_id = ('57158160899'::bigint))
Planning time : 1.986 ms
Execution time : 16,655.781 ms