explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HJ4C

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=34,697.89..34,697.89 rows=1 width=16) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=34,697.89..34,697.89 rows=1 width=16) (actual rows= loops=)

  • Sort Key: export_log.create_date DESC
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,035.95..34,697.88 rows=1 width=16) (actual rows= loops=)

  • Join Filter: (export_log.id_user = workers.id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on workers (cost=0.00..222.32 rows=1 width=4) (actual rows= loops=)

  • Filter: ((lower((name)::text) ~~ '%%'::text) AND (lower((name)::text) ~~ '%іменін%'::text))
5. 0.000 0.000 ↓ 0.0

Gather (cost=1,035.95..34,449.64 rows=2,073 width=20) (actual rows= loops=)

  • Workers Planned: 2
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=35.95..33,242.34 rows=864 width=20) (actual rows= loops=)

  • Hash Cond: (export_log.id_dist = groups.id)
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on export_log (cost=0.00..32,908.86 rows=109,685 width=30) (actual rows= loops=)

  • Filter: (id_dist = ANY ('{59,9,61,63,64,66,67,94,3,45,69,70,71,72,56,57,46,73,74,75,76,77,78,79,82,83,84,85,86,87,90,91,92,93,99,100,101,102,103,104,105,106,1,10,7,95,97,98,107,108,122,4,6,47,109,110,111,112,113,114,116,117,118,119,120,121,123,48,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,11,53,60,49,54,55,5,52,62,68,80,81,8,58,44,50,65,88,115,51,89,142,0,-1}'::integer[]))
8. 0.000 0.000 ↓ 0.0

Hash (cost=35.94..35.94 rows=1 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using groups_pkey on groups (cost=0.14..35.94 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = ANY ('{59,9,61,63,64,66,67,94,3,45,69,70,71,72,56,57,46,73,74,75,76,77,78,79,82,83,84,85,86,87,90,91,92,93,99,100,101,102,103,104,105,106,1,10,7,95,97,98,107,108,122,4,6,47,109,110,111,112,113,114,116,117,118,119,120,121,123,48,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,11,53,60,49,54,55,5,52,62,68,80,81,8,58,44,50,65,88,115,51,89,142,0,-1}'::integer[]))
  • Filter: ((lower((group_name)::text) ~~ '%гермес%'::text) AND (lower((group_name)::text) ~~ '%тов%'::text) AND (lower((group_name)::text) ~~ '%(хмельницкий%'::text))