explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N6LL

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 45,593.032 ↓ 0.0 0 1

Limit (cost=1,000.89..5,575.65 rows=26 width=102) (actual time=45,593.032..45,593.032 rows=0 loops=1)

2. 0.000 45,595.588 ↓ 0.0 0 1

Gather Merge (cost=1,000.89..32,122,343.17 rows=182,557 width=102) (actual time=45,593.030..45,595.588 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 38,362.599 136,761.918 ↓ 0.0 0 3

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

  • -> Index Scan using societies_society_pkey on societies_society (cost=0.14..0.16 rows=1 width=4) (actual time=0.002..0.
4. 98,399.319 98,399.319 ↑ 1.7 4,388,575 3

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

  • -> Parallel Index Scan using cwrtransact_creatio_b3c456_idx on cwrtransactions_transaction (cost=0.44..17393727.0
  • -> Index Scan using cwrfiles_ackfile_pkey on cwrfiles_ackfile (cost=0.29..1.83 rows=1 width=8) (actual time=0.002
  • Index Cond: (id = cwrtransactions_transaction.ack_file_id)
  • Index Cond: (id = cwrfiles_ackfile.society_id)
  • Filter: ((name)::text = 'ACUM'::text)
  • Rows Removed by Filter: 1