explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8be7 : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 55,668.826 ↓ 0.0 0 1

Gather Merge (cost=1,000.89..32,122,343.17 rows=182,557 width=102) (actual time=55,668.633..55,668.826 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 23,730.845 166,949.043 ↓ 0.0 0 3

Nested Loop (cost=0.86..32,100,271.54 rows=76,065 width=102) (actual time=55,649.681..55,649.681 rows=0 loops=3)

3. 42,770.584 116,886.750 ↑ 1.7 4,388,575 3

Nested Loop (cost=0.72..30,891,472.56 rows=7,378,336 width=106) (actual time=18.143..38,962.250 rows=4,388,575 loops=3)

4. 38,688.942 38,688.942 ↑ 1.2 5,904,537 3

Parallel Index Scan using cwrtransact_creatio_b3c456_idx on cwrtransactions_transaction (cost=0.44..17,393,727.08 rows=7,378,336 width=102) (actual time=0.026..12,896.314 rows=5,904,537 loops=3)

5. 35,427.224 35,427.224 ↑ 1.0 1 17,713,612

Index Scan using cwrfiles_ackfile_pkey on cwrfiles_ackfile (cost=0.29..1.83 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=17,713,612)

  • Index Cond: (id = cwrtransactions_transaction.ack_file_id)
6. 26,331.448 26,331.448 ↓ 0.0 0 13,165,724

Index Scan using societies_society_pkey on societies_society (cost=0.14..0.16 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=13,165,724)

  • Filter: ((name)::text = 'ACUM'::text)
  • Rows Removed by Filter: 1