explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hpU1

Settings
# exclusive inclusive rows x rows loops node
1. 1,811.637 21,071.495 ↓ 7.3 5,696,773 1

Hash Join (cost=1,796.39..146,929.58 rows=784,728 width=4) (actual time=105.525..21,071.495 rows=5,696,773 loops=1)

  • Hash Cond: (mess2.conversation_id = "*VALUES*_1".column1)
2. 1,588.708 19,208.479 ↓ 7.2 5,879,466 1

Nested Loop (cost=0.44..134,208.40 rows=820,788 width=8) (actual time=52.429..19,208.479 rows=5,879,466 loops=1)

3. 0.363 0.363 ↑ 1.0 62 1

Values Scan on "*VALUES*" (cost=0.00..0.78 rows=62 width=4) (actual time=0.015..0.363 rows=62 loops=1)

4. 17,619.408 17,619.408 ↓ 7.2 94,830 62

Index Scan using bot_id_index on messages mess2 (cost=0.44..2,032.25 rows=13,239 width=12) (actual time=23.015..284.184 rows=94,830 loops=62)

  • Index Cond: (bot_id = "*VALUES*".column1)
5. 22.076 51.379 ↑ 1.0 71,838 1

Hash (cost=897.98..897.98 rows=71,838 width=4) (actual time=51.379..51.379 rows=71,838 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 3550kB
6. 29.303 29.303 ↑ 1.0 71,838 1

Values Scan on "*VALUES*_1" (cost=0.00..897.98 rows=71,838 width=4) (actual time=0.013..29.303 rows=71,838 loops=1)

Planning time : 265.820 ms
Execution time : 21,416.945 ms