explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xxXV

Settings
# exclusive inclusive rows x rows loops node
1. 16.657 9,825.839 ↑ 113.8 21,654 1

HashAggregate (cost=573,893.63..598,531.93 rows=2,463,830 width=8) (actual time=9,815.796..9,825.839 rows=21,654 loops=1)

2. 1.868 9,809.182 ↑ 113.7 21,664 1

Append (cost=274.04..567,734.05 rows=2,463,830 width=8) (actual time=0.059..9,809.182 rows=21,664 loops=1)

3. 0.009 0.062 ↑ 67.5 14 1

HashAggregate (cost=274.04..283.49 rows=945 width=8) (actual time=0.059..0.062 rows=14 loops=1)

4. 0.007 0.053 ↑ 67.5 14 1

Nested Loop (cost=0.86..271.68 rows=945 width=8) (actual time=0.033..0.053 rows=14 loops=1)

5. 0.016 0.016 ↑ 1.3 3 1

Index Only Scan using index_phish_report_on_investigation_id_and_forensics_id on phish_report (cost=0.42..2.49 rows=4 width=8) (actual time=0.016..0.016 rows=3 loops=1)

  • Index Cond: (investigation_id = 115,248)
  • Heap Fetches: 0
6. 0.030 0.030 ↑ 69.6 5 3

Index Scan using _mfrisch_index_ip_investigation_on_forensics_id on ip_investigation (cost=0.44..63.82 rows=348 width=12) (actual time=0.008..0.010 rows=5 loops=3)

  • Index Cond: (forensics_id = phish_report.forensics_id)
7. 3.110 9,807.252 ↑ 113.8 21,650 1

Unique (cost=524,340.62..542,812.26 rows=2,462,885 width=8) (actual time=9,797.724..9,807.252 rows=21,650 loops=1)

8. 3.834 9,804.142 ↑ 113.8 21,650 1

Group (cost=524,340.62..536,655.05 rows=2,462,885 width=8) (actual time=9,797.724..9,804.142 rows=21,650 loops=1)

9. 10.355 9,800.308 ↑ 108.8 22,645 1

Sort (cost=524,340.62..530,497.83 rows=2,462,885 width=8) (actual time=9,797.721..9,800.308 rows=22,645 loops=1)

  • Sort Key: ip_investigation_1.id
  • Sort Method: quicksort Memory: 1,830kB
10. 10.313 9,789.953 ↑ 108.8 22,645 1

Nested Loop (cost=0.87..262,881.76 rows=2,462,885 width=8) (actual time=0.039..9,789.953 rows=22,645 loops=1)

11. 4.882 4.882 ↑ 1.1 5,023 1

Index Scan using _nb_index_investigation_message_on_investigation_id on investigation_message (cost=0.43..550.87 rows=5,639 width=8) (actual time=0.014..4.882 rows=5,023 loops=1)

  • Index Cond: (investigation_id = 115,248)
12. 9,774.758 9,774.758 ↑ 69.6 5 5,023

Index Scan using _mfrisch_index_ip_investigation_on_forensics_id on ip_investigation ip_investigation_1 (cost=0.44..43.04 rows=348 width=12) (actual time=0.068..1.946 rows=5 loops=5,023)

  • Index Cond: (forensics_id = investigation_message.forensics_id)
Total runtime : 9,832.922 ms